package com.niit.mall.product.mapper;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.niit.mall.product.domain.po.Brand;
import com.niit.mall.product.domain.vo.BrandVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @BelongsProject: pardo_mall_backend
 * @BelongsPackage: com.niit.mall.product.mapper
 * @Author: ChuXuan
 * @CreateTime: 2025-06-08  01:10
 * @Description: 品牌Mapper
 * @Version: 1.0
 */
@Mapper
public interface BrandMapper extends BaseMapper<Brand> {
    /**
     * 查询品牌信息
     * @return 品牌信息列表
     */
    @Select("select id, brand_name, create_date, update_date, is_deleted, version " +
            "from `pardo-product`.tb_brand " +
            "where is_deleted = 0")
    List<Brand> queryBrand();

    /**
     * 查询品牌信息VO
     * @return 品牌信息VO列表
     */
    @Select("select id, brand_name from `pardo-product`.tb_brand where is_deleted = 0")
    List<BrandVO> queryBrandVO();
}
